Course Project

 

 

Project 1. the Practice of Object-oriented Database

Objective

  • Learn how to install and use object-oriented database.
  • Know how to create table, the object-oriented way.

Content

  1. Install Oracle 11g, an object-oriented database system;
  2. Create an user-defined type address, including three members-province, city and street;
  3. Create a table that includes address and use insert statement to add records;
  4. Use select statement to query data through alias;
  5. Use delete statement to remove data from a table;
  6. Create a parent type person that includes at least three members;
  7. Create a children type student that inherits from person and add three more members at least;
  8. Use create view statement to create object's view.

Report

Follow the instructions inside the doc file and finish the project:

Report.doc

Project 2. the Usage of XML Database

Objective

  • Know the basic operations in OreintX database.
  • Use XPath and XQuery to do the data indexing.

Content

  1. Download and install OrientX 3.5, an XML database system;
  2. Create an XML file of personal information with at least 5 attributes;
  3. Use XPath or XQuery, both are the query languages, to retrieve data.

Report

Follow the instructions inside the doc file and finish the project:

Report.doc

Project 3. the Usage of PostgreSQL

Objective

  • Learn how to install and use PostgreSQL database.
  • Learn how to query data at server-end using 3rd party programming languages.

Content

  1. Install PostgreSQL database system, at both the server-end and clint-end;
  2. Create three tables-students, courses and selectCourse; add 5 students, 3 courses , and 10 selection records into each table, respectively;
  3. Use select statement to query data from tables (distinct, in, like and order by operations are needed!);
  4. Use insert, update , and delete statements to add, change , and delete data;
  5. Write PostgreSQL functions using simple Python language at server-end to query data from .

Report

Follow the instructions inside the doc file and finish the project:

Report.doc

Project 4. Oracle RAC Cluster

Objective

  • Learn how to depoly and set up a Oracle RAC cluster.

Content

  1. Set up RAC hardware; server environment consists of two hosts; storage environment has one shared storage and one exchanger; inner network environment is one exchanger connecting several hosts; outer network environment is responsible for external communication via one data server connecting an exchanger;
  2. Set up RAC software; server adopts Redhat Enterprise 5; cluster middleware adopts Oracle Clusterware; cluster file system adopts ASM; Database system isOracle 10g;
  3. Configure Oracle RAC;
  4. Create tables; test operations like add, remove, or change, etc.

Report

Follow the instructions inside the doc file and finish the project:

Report.doc

Project 5. the Implement of Database Index

Objective

  • Implement the database index by learning B+ Tree.

Content

  1. Learn the basic concepts of index and B+ Tree;
  2. Implement a simple B+ Tree (operations like insert, delete, and search are needed);
  3. Use B+ tree to store indexing information of a database; analyze its performance.

Report

Follow the instructions inside the doc file and finish the project:

Report.doc

Project 6. the Design and Implement of a Company's Financial Information Database

Objective

  • An example to help you grasp the idea of database design and implementation.

Content

  1. Requirements analysis;
  2. Draw E-R diagram; convert the diagram to relational model;
  3. Create tables according to the relational model;
  4. Create querys and views according to our needs;
  5. Optimize the database.

Report

Follow the instructions inside the doc file and finish the project:

Report.pdf
   

 

 

TOP